﻿
IF object_id(N'dbo.[UDS_Schedule]', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_Schedule] (
        [ID]        int          NOT NULL identity(1, 1),
        [PeriodID]  int          NOT NULL,
        [TaskID]    int          NOT NULL,
        [Username]  nvarchar(20) COLLATE Chinese_PRC_CI_AS NULL,
        [Date]      datetime     NULL,
        [IsConfirm] int          NULL,
        [Reason]    nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,

        CONSTRAINT [PK_UDS_Schedule] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
